Creating an Excel file

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: Creating an Excel file

Feedback Type: Question

Product Area: Notes Client

Technical Area: Application Development

Platform: Windows

Release: 8.5.3

Reproducible: Not applicable

I am trying to set a date format on on Excel export, if I know the column letter, the below works.

Set excelSheet = excelNewWkbk.ActiveSheet
Set cell = excelSheet.Columns("D")
cell.NumberFormat = "dd/mm/yyyy"

The issue I am having is that we allow the user to order the columns to there own requirments, which means I don't know the colomn letter that the date field will be in, but (because of the LS code looping) I know the number ie 2 = B, 5= E, so I want to set the format based on the coloumn number, I believe the syntax is something like Range(Columns(4), Columns(4)).Select but I can't seem to get this working in LotusScript with NumberFormat, has anyone got an example of selecting column (based on a number) then applying a NumberFormat?

Feedback number WEBB9D9LQB created by ~Sigmund Bubjipylynivu on 11/08/2013

Status: Open
Comments: